Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL IOSTATS qualifier

Provides current I/O statistics for active databases.

Syntax

proutil db-name -C iostats

Parameters

db-name

Specifies the active database where you are running database I/O statistics.

The statistics provided PROUTIL IOSTAT include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup.

Example

The following output is a sample display of PROUTIL IOSTATS:

Database name is sports (2524) FILE          BUFFERED        UNBUFFERED          LOGICAL (2556)             Writes  Reads    Writes  Reads   Reads  Writes  Extends (2557) ========================================================================== sports.b1       0      0        317    389     388     252        2 sports.d1       1    173         11      0     171      11        0 sports_7.d1   773   6792          0      0    6790     772        0 sports_7.d2   270   1702         10      0    1701     269        4 sports_8.d1   649    715          0      0     713     648        0 sports_8.d2     1      1          0      0       0       0        0 sports_9.d1     1      2          0      0       0       0        0 sports_9.d2     1      1          0      0       0       0        0 sports_10.d1    1      2          0      0       0       0        0 sports_10.d2    1      1          0      0       0       0        0

FILE

Displays the name of the file where the statistics are displayed. The file types can include: database files (.db extensions), Before-image files (.bi extensions), After-image files (.ai extensions), and application data extents (.dn extensions).

BUFFERED

Displays the number of buffered reads and writes to the database file for the associated row.

UNBUFFERED

Displays the number of unbuffered reads and writes to the database file for the associated row.

LOGICAL

Displays the number of client requests for database read and write operations for the associated row.

Notes

The statistics are cumulative and are reset at database open.
IOSTATS is available only on multi-user databases.
IOSTATS provides a useful alternative to PROMON when you are only interested in statistics on your database extents.
You can use IOSTATS to determine if your files are opened in buffered or unbuffered mode.